CREATE TABLE [dbo].[tb_Padron]
(
[sexo] [int] NOT NULL,
[documento] [int] NOT NULL,
[clase] [decimal] (4, 0) NOT NULL,
[apellido] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[nombre] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[domicilio] [char] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[seccion] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[circuito] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[codprof] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[profesion] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[tipodoc] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[estab] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[domestab] [char] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [IX_tb_padron2] ON [dbo].[tb_Padron] ([documento]) ON [PRIMARY]
GO
